import xlwings as xw

wb = xw.Book()  # 创建新的工作簿
sht = wb.sheets['Sheet1']  # 实例化工作表
sht.range('A1').value = 'Hello World!'  # 写入
print(sht.range('A1').value)  # 读取
wb.save('test5.xlsx')  # 保存
wb.close()
